package com.hjc.springbootmovies.mapper;

import com.hjc.springbootmovies.entity.ModelMoney;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Created by IntelliJ IDEA.
 * User: HJC
 * Date: 2020/1/1
 * Time: 18:41
 * To change this template use File | Settings | File Templates.
 */
@Mapper
public interface MappingMoney {

    @Select("select count(f.fname) as num , f.fname , h.tname , b.begintime,b.endtime ,b.xmoney " +
            "from sale s " +
            "left join broad b on s.xid = b.xid " +
            "left join hall h on b.tid = h.tid " +
            "left join fiml f on f.fid = b.fid " +
            "GROUP BY f.fname , h.tname , b.begintime , b.endtime,b.xmoney ")
    List<ModelMoney> queryAll();
}
